Skip to content
Advertisement

how to get multiple columns from subquery inseide sql statement mysql

actually, I found many solutions for my issue but I didn’t understand how to apply to my issue!

my issue is I have the following SQL statement:

what I need is to replace the following part in one part:

to get the all columns in one subquery with the same conditions?

Advertisement

Answer

I don’t know your data schema. Do you try making a CROSS JOIN (first) and a LEFT JOIN with table tblproductsprices?

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement