Hello Dev,
Please help me with sql code to achieve the third table i.e transaction record using tblcustomer and tbltransaction table

Image below

SELECT customer.Fullname AS CustomerName, transaction.Operation AS TypeOfOperation, transaction.Amount
FROM transaction
INNER JOIN customer ON customer.ID = transaction.ID



That's the SQL query. I also attached screen shot

God bless You

will implement.

Thenaijaitguy:
SELECT customer.Fullname AS CustomerName, transaction.Operation AS TypeOfOperation, transaction.Amount
FROM transaction
INNER JOIN customer ON customer.ID = transaction.ID



That's the SQL query. I also attached screen shot

In a real system, a guest can not perform transaction. Except if you have Another table named quest .then you can joint it also.

Instead,try use right join.

[quote author=walterjnr post=98947008][/quote]


Bro,
1. You see that second table that you have a column called customer name, and instead you are putting customer id (2,1) and you still added a string called guest, it's very very wrong.

That place should be cudtomer_id and only the id of customers in the first table should be in that second table column.

2. A guest can't ever make a transaction. Everyone must be registered to have an id that will be in that second table column called customer name.


3. Also for safety and clarifications don't write deposited or withdrawal as a transaction type. Instead reference with with either 1 or 2.

It appears you are a newbie into programming? Well done...just continue practising you'll surely get there.

Cheers