Select rows from 2 or more tables where a record may not exist in tabl

[mckenneyj]

All match records are in table 1
Table 2 houses a subset of table 1

Table 1 has 2000 rows
Table 2 has 5000 rows
select x,y,z from table 1 where id = 'x' yeilds 1000 rows
select x,a,b,c from table 2 where id = 'x' yeilds 500 rows

This is because table only holds a subset of the data where the matching 'x' may or may not exist

My query needs to show all 1000 rows from table 1 and the colums from table 2 where a record does exist

x y z a b c
1 12 13 14 15 16
2 22 23
3 33 34 35 36 37
4 44 45
5 55 56 57 58 59

Thanks,
John McKenney
Work Hard... Play Harder

 

[monksnake]

I see this:

My query needs to show all 1000 rows from table 1 and the colums from table 2 where a record does exist

And this:
[/quote]
Table 2 houses a subset of table 1
[/quote]

So wouldn't you just show the 1000 rows from table 1 as any row from table 2 would already be in table 1???





<.

 

[mckenneyj]

The colums in table 2 hold different data

Thanks,
John McKenney
Work Hard... Play Harder