Code: Select all
SELECT * FROM bank JOIN cash ON bank.category=cash.category WHERE bank.category = ?
Personal computing discussed
Moderators: renee, SecretSquirrel, just brew it!
SELECT * FROM bank JOIN cash ON bank.category=cash.category WHERE bank.category = ?
tblBank tblCash
----------------------- --------------------------
20151002, "Food", 5.00 20151002, "Clothes", 55.00
20151002, "Car", 27.00 20151004, "Pets", 3.00
20151003, "Cell", 35.00 20151006, "Food", 7.00
20151004, "Pets", 10.00 20151008, "Food", 10.00
select *
from tblBank join tblCash on tblBank.Category = tblCash.Category
where tblBank.Category = "Food"
20151002, "Food", 5.00, 20151006, "Food", 7.00
20151002, "Food", 5.00, 20151008, "Food", 10.00
dmjifn wrote: