Is there a solution to fetch data from 2 tables without left join?

Question

I have this problem, which it's keeping me out of focus from the main project on Laravel.

I have 2 tables without any fk on them

TableA:
id(INT)
Name(VARCHAR)
EventId(INT)
PlayerChoiceId(INT)

and

TableB:
id(INT)
PlayerChoice(VARCHAR)
PlayerColor(VARCHAR)

I need to make a method on my controller to select all of the data from TableA with the PlayerChoice value, not the id from TableB, but without LEFT JOIN.

Example: id(TableA)|Name|EventId|PlayerChoice

Because when i tried the LEFT JOIN in PHPMyAdmin, i found it returns me, 2 columns of "id" — Bogdan Marian Muntean, Nov 18 '20 at 00:35
That's because you probably used `SELECT *`. You can choose what to select. — El_Vanja, Nov 18 '20 at 00:42

score 0 · Accepted Answer · answered Nov 18 '20 at 00:58

0

Something like:

SELECT a.*, b.PlayerChoice from TableA a, TableB b where a.PlayerChoiceId = b.id;

Will give you:

a.id a.Name a.EventId a.PlayerChoiceId b.PlayerChoice

is that what you're looking for?

answered Nov 18 '20 at 00:58

Danial

1,496
14
15

Something like that, in fact, I was more interested in the JSON output to return with the value in the PlayerChoice(TableB) column for the PlayerChoiceId(TableA) column. Something like this:[ { "id": 1,"name": "Name","EventId": 1, "PlayerChoice": "yes"}], instead of: [ { "id": 1,"name": "Name","EventId": 1, "PlayerOption":"1","PlayerChoice": "yes"}] I've had already implemented in older version of the app a table in HTML using a single SQL table and the structure was like this: id|Name(VARCHAR)|EventName(VARCHAR)|PlayerChoice(VARCHAR). – Bogdan Marian Muntean Nov 18 '20 at 01:46
Now,after some migrations, i altered the table, and the PlayerOption(PlayerChoiceId in the example) only changed from varchar to int, and the name of the column remains unchanged, the data from this column was moved to the new table(TableB), to store the id from the TableB. But i think it's ok, i'm going to modify the HTML table. – Bogdan Marian Muntean Nov 18 '20 at 01:46

Is there a solution to fetch data from 2 tables without left join?

1 Answers1