okay, I would understand not using right join and inner join.
But how can you be a DBA and not use full outer join or cross join?
Its also true that unless your work is DE or BI analyst, I guess people are not using SQL up to that point.
But how can you be a DBA and not use full outer join or cross join?
Its also true that unless your work is DE or BI analyst, I guess people are not using SQL up to that point.
I've rarely had to use a full outer join; I think that if you encounter that need, it bespeaks a problem with your schema. But sometimes DBAs are extremely resistant to schema changes in production, so you have to work with the schema you have.
FWIW, SQL isn't the core of my trade; I'm not a data analyst, I'm just a normal dev with SQL as one of the things in my toolkit.
For full outer join, well you need to create dim tables sometimes half ad-hoc and full outer seems to be much faster solution than UNION