Select statement.. help please

sarah lee · May 16th, 2007, 07:24 AM

hi all :)

can anyone please help me to get a simple select stmt?

i have 3 tables

table1
compid
name

table2
tb2id
compid
recordid

table3
recordid
name

how can i get all the compid, with recordid?

Thank you

happygv · May 16th, 2007, 07:34 AM

Is this what you are looking for?

Code:

SELECT * FROM table1 a, table2 b, table3 c
Where a.compid = b.compid and b.recordid = c.recordid

_________________________
- Vijay G
Strive for Perfection

sarah lee · May 16th, 2007, 07:43 AM

Thanks for the reply.
Sorry for the confusion, a small change in the table3 fields

table3
recid
name

I dont know how to do inner join.
i tried like this, but it gives error.
It will be greatful, if you can point out where i have gone wrong?
OR is this not the way?

Code:

select top 100 percent dbo.table1.[compid] from dbo.table1 inner join 
dbo.table2 on dbo.[table3]
where dbo.table2.[recordid] = dbo.[table3].[recID]

Thank you

happygv · May 16th, 2007, 09:00 AM

Ideally the join should be like this.

Code:

select top 100 percent dbo.table1.[compid] from dbo.table1 inner join 
dbo.table2 on dbo.table2.[compid] = dbo.[table1].[compid] inner join
dbo.[table3] on dbo.table2.[recordid] = dbo.[table3].[recID]

And see if you are doing the correct type of join for your expected result.

_________________________
- Vijay G
Strive for Perfection

sarah lee · May 16th, 2007, 09:13 AM

Thank you.
I got it worked