Possible to select* off of Joined table?
Consider this SQL query
I have it converted to this Drizzle query, which looks to be correct.
My question is, is it possible to just
select *
from the joined table, without listing out every field?
I realize I could probably flip the query around and do a right join, but I don't want to do that; I'd rather keep listing out all the fields if that's my only option.
Does Drizzle have a shortcut for this?3 Replies
I similarBooks another table or is this a self join?
If it is another table you could simply do
You're too fast - yep - I discovered that also. Was about to add that info here.
Thanks so much!