instead of separate where condition use the condition in join statement only

select c.* ,t.name from tempdb.sys.columns c
INNER JOIN tempdb.sys.tables t
on (c.object_id = t.object_id
and t.name = '#tmp_table');

Hello, i had done this in oracle. see what i had did. created the tables

create table tqw1(t1c1 varchar2(10),t1c2 varchar2(10),t1c3 varchar2(10),t1c4 varchar2(10));
create table tqw2(t2c1 varchar2(10),t2c2 varchar2(10),t2c3 varchar2(10),t2c4 varchar2(10));
create table tqw3(t3c1 varchar2(10),t3c2 varchar2(10),t3c3 varchar2(10),t3c4 varchar2(10));
create table tqw4(t4c1 varchar2(10),t4c2 varchar2(10),t4c3 varchar2(10),t4c4 varchar2(10));

insert some random data into those tables

insert into tqw1(t1c1,t1c2,t1c3,t1c4) values (7,2,3,4);
insert into tqw2(t2c1,t2c2,t2c3,t2c4) values (8,3,4,5);
insert into tqw3(t3c1,t3c2,t3c3,t3c4) values (9,4,5,6);
insert into tqw4(t4c1,t4c2,t4c3,t4c4) values (10,5,6,7);

see there was no relation among these tables. so i had used alias with the tables to select a particular data set

select Q.T1C1,W.T2C2,E.T3C3,R.T4C4 from tqw1 q,TQW2 w,TQW3 e, TQW4 r ;

need the use where clause to filter the data

Hello Jassim, while working in a procedure then i got the same problem. so based on my experience i would suggest to use decode function. decode function is similar to if else block.

decode(floor_id,null,1,floor_id)=decode(param_floor,null,1,param_floor)

thanks in advance regards, Sundeep

Friends i am going to develop a website which is like you tube.so i want to play an add first then i want to play the video on clicking the video file.so help me in writing the code. i wish to use two databases one for adds and other for videos.so please help me writing code

Sundeep

thank you friend. so you are suggesting me to develop in asp.net can i embedded database in this project?

is there any other alternative rather than ASP.net?

Are you saying to use c#? but how i can connect to the speech?

is ASP.net is compatible with speech?:confused:

friends i am going to start a project for the great mind challenge 2012 which is "VOICE BASED WEB BROWSER" but i am in confused state how i can start this project? if u have any suggestion please tell me? if u have any ideas how the browser look like? so that i can analyze ideas and my project will be successful.