I need sql query that do the following
[url removed, login to view] certain items from items table.
2..Select certain restaurants from restaurants table.
[url removed, login to view] sum of items quantity from RequisitionDetails table for each restaurant in certain date.
[url removed, login to view] item not existed in selected date or not existed in RequisitionDetails table at all for certain restaurant it should be empty.
[url removed, login to view] the total
data base backup and script are included in the attachment.
out put should be like this
Cod ItemName Unit res1 res 2 res3 Total
1 item1 kg 4.00 5.00 3.00 12.00
2 item2 kg 2.00 Null 1.00 3.00
21 freelancers are bidding on average $28 for this job
I have a candidate who is having 6+ years of SQL Database experience and he is currently working in MNC. So we can complete your work with quality and within timeframe.
Hello Sir, I am a php developer and able to create such query and fetch data from your database on the following condition. i am working in IT Field from last 4 years. thanks!!!