Topic: The optimal approach to sampling
There is table A in which there is 1 field "name" varchar (20). In the table 2 lines.
In the table In the same field + what that additional parameters contains.
It is necessary to obtain all data from the table In where a field "name" equally I weed "name" from the table And.
From for the huge size of the table which I write To any request dies, did not wait still any performance.
(Ps - the Table And I can , In possibility is not present)
Select * from B inner join A on b.name = a.name
Select * from B where name in (Select name from A)
Select a.name, b.* from A inner join B on a.name = b.name
It is fulfilled nothing, I wait hours.