Scribd
Upload
45 views1 page

SQL Query for Mie Rampok Sales Data

The document contains a SQL query that retrieves data from multiple tables including outlet, perusahaan, device_app, saleitemdetail, and sale. It filters the results for a specific outlet named 'Mie Rampok Manukan Surabaya' and a sale date of '2017-05-11'. The query aims to join relevant data based on specific identifiers across the tables.

Uploaded by

bambang pardianto
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
45 views1 page

SQL Query for Mie Rampok Sales Data

The document contains a SQL query that retrieves data from multiple tables including outlet, perusahaan, device_app, saleitemdetail, and sale. It filters the results for a specific outlet named 'Mie Rampok Manukan Surabaya' and a sale date of '2017-05-11'. The query aims to join relevant data based on specific identifiers across the tables.

Uploaded by

bambang pardianto
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SELECT * FROM outlet

JOIN perusahaan ON [Link] = [Link]


JOIN device_app ON device_app.DeviceID = [Link]
JOIN saleitemdetail ON [Link] = [Link]
JOIN sale ON [Link] = [Link]
WHERE NamaOutlet = "Mie Rampok Manukan Surabaya"
AND SaleDate = "2017-05-11"

You might also like