Phoenix - Your AI AssistantI need help with SQL query for mysql db
- Posted:
- Proposals: 12
- Remote
- #1496238
- Awarded
Sargodha 
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the website: other
Database management system (DBMS): MySQL
Description of requirements/features: We require help with sql statement for mysql db.
Simply we have three tables
1 Products (id, name, model, year)
2.Contacts (First name, last name, address, emails etc)
3 SalesInfo (sale_id,product name, seller1, seller2, buyer1, buyer2, agreementdates etc, agreed_price)
So we need for each sale:
Sales dates,
Product Name and Model etc
seller1 name address email
seller2 name address email
buyer1 name address email
buyer2 name address email
agreedprice
curr
closing date
We have it mostly working but we need
to pull in multiple contact details into the statement.
We use this to send to Webmerge to generate contracts and statements etc.
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/features: We require help with sql statement for mysql db.
Simply we have three tables
1 Products (id, name, model, year)
2.Contacts (First name, last name, address, emails etc)
3 SalesInfo (sale_id,product name, seller1, seller2, buyer1, buyer2, agreementdates etc, agreed_price)
So we need for each sale:
Sales dates,
Product Name and Model etc
seller1 name address email
seller2 name address email
buyer1 name address email
buyer2 name address email
agreedprice
curr
closing date
We have it mostly working but we need
to pull in multiple contact details into the statement.
We use this to send to Webmerge to generate contracts and statements etc.
Extra notes:
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.