Use one select query for two different table

[Schetan]

hi,
I am working in asp.net with sqlserver2005. i am stored car information in one table an image for that car in other table. i can also stored that image id with respective car. I want to show some car information with it photo in datagrid.
But how can i select that both table in on single query

Please guide me.

Thanks
Schetan

[idsanjeev]

Hi
if you able to display the data selected in sql query then the select statement is

select a.fieldname1,a.fieldname2,a.fieldname3,b.fieldname1,b.fieldname2,b.fieldname3 from table1 a,table2 where a.fieldname1=b.filedname2
 

in where clause one filed data is common in both table for jointing them
Regards
jha

[vikas251074]

Hi
if you able to display the data selected in sql query then the select statement is

select a.fieldname1,a.fieldname2,a.fieldname3,b.fieldname1,b.fieldname2,b.fieldname3 from table1 a,table2 where a.fieldname1=b.filedname2
 

in where clause one filed data is common in both table for jointing them
Regards
jha

I am sure this will not work because image will not display this way. There could be another method.

Thanks and regards,
Vikas

[jhardman]

I am sure this will not work because image will not display this way. There could be another method.

Thanks and regards,
Vikas

Idsanjeev's solution is correct. He did not address the question of displaying the photo, just how to query both tables with a single query.

Jared