Search results for query: *

Thank you for the reply tlbroadbent! Unfortunately it brings back too much. There is criteria for the table1 ("Author"). Adding this criteria ("LastName = 'Wilson'") then makes the query: SELECT a.FirstName, a.LastName, b.BookTitle, b.Year FROM Author AS a LEFT JOIN Book...

Thank you Quehay and dalchri. I appreciate the time to look at my problem. I have found several multi-query solutions, although dalchri's is a new one to me. I don't fully understand why it does work, but I'll be studying it more to find out. Thankfully, time was not an issue on this (only a...

if it helps other people, here is what I want: I have 2 tables, "Author" and "Book" the contents of the Author table: SSN FirstName LastName 111111111 Adam Wilson 222222222 Emily Wilson 333333333 Arthur Jones 444444444 Syed Karimushan 555555555 Alexandra Wilson the...

I feel your pain, and unfortunately I haven't found the answer anywhere. The left join acts like an inner join when you have criteria in the right table, and that's just not what we want! If you do find an elegant solution, could you please post here? I found a round about way using a...