[reddi lol]

Select a.field, b.field
From table a
Left join table b
On a.field2 = b.field2
Where naezisretard = 'Y';

L0l I haz sum cum loud degree from Internet skewlz pr0grammin