🔒 Closed Pa help naman po sa sql ko

[gw3n]

pano po ba yung tamang query nito mga papi di ko kase makuha eh ganyan lang dapat yung lalabas pag nacompile eh

ganyan yung saakin mga papi

kaso iba yung nalabas sakin di ko alam kung anong klaseng join or union ilalagay ko pa help po thanks..

 

[teapotpot]

Lahat ng columns yung output niya kasi naka SELECT * ispecify mo lang yung column na gusto mong iretrieve niya ex. SELECT inv_num, cust_num, cust_lname and so on.

 

[PHC-John-Bore]

Use left join
Note.. Must have the same column name both invoice and customer table for referencing record.

Use left join
Note.. Must have the same column name both invoice and customer table for referencing record.

And identify the column(s) name that you want to get instead of using * (all)