SQLTeam.com | Weblogs | Forums



How to create query for below data


We need usable sample data -- CREATE TABLE and INSERT statement(s) -- not just pictures of data. We can't run code we write on a picture of data :smiley:

seems pretty straightforward, not sure what you've tried. Looks something like select * from Table1 join Table2 on (whatever join is to Table1) left join Table3 on (whatever join is to Table2)