I have two databases, database A and B which each have a table named general_table. How can I write a query that will do a cross search on both general_tables depending on Barcode Number (Each table contains Barcode Number) with connection:
$connect = mysqli_connect('localhost', 'pharmana_general', '123456', 'A');
It sounds like, based on what you're trying, the best solution would be a union:
SELECT a.* FROM pharmana_Hareket_db.`general_Table` a
UNION
SELECT b.* FROM pharmana_urun_db.`general_Table` b
Building on the above example, you could do:
SELECT a.* FROM pharmana_Hareket_db.`general_Table` a
WHERE a.barCodeField = 1234567980
UNION
SELECT b.* FROM pharmana_urun_db.`general_Table` b
WHERE b.barCodeField = 1234567980
You could of course a use JOIN, depending on the data set up, but it sounds like a UNION would work for you.
Edit: I have just read that you want both, so you could try a join
SELECT * FROM pharmana_Hareket_db.`general_Table` a
INNER JOIN pharmana_urun_db.`general_Table` b
ON a.barCodeField = b.barCodeField
...which should only return rows that have matching barcodes in both DBs
database.table.column