This is probably a no-brainer for most but I'm a bit of a newbie in mysql query:
If anyone could give me an example of the "Edit SQL Query"
I need to creat a Pickup Ticket for a driver that has data from two separate tables. One table contains detail about what the driver is picking up the other table contains data about the loading site, tank number & directions. I have omitted some fields from the records that are unimportant for the example. There is a field in each table that is the joining record. This is a project involving crude oil pickups.
Here are examples of the table:
_ticket
ticketnumber
wellid
date
product
operator
_well
wellid
tanknumber
directions
When _ticket.welld = _well.wellid
On The report I want:
_ticket.ticketnumber
_ticket.wellid
_ticket.date
_ticket.product
_ticket.product
_ticket.operator
_well.tanknumber
_well.directions
As you can see the well Id# is in each table.
Please, what should my SQL Query look like?
