Sql tables

Question

Hi, I am having a problem with 2 tables I have joined. I am trying to get the data not included in one table comparing to another. from the table A i have all the data i am joining to have all the data extracted but i know i can place a is null or some other command to get the specific field on table B to get what I am leaving out. is this corect?

Answer 1

Can you please post your code here?

Answer 2

Select Distinct A.branch, A.item, A.cost, B.component
From cost as A right join component as B on a.item = B.item
Where A.branch = " x " and A.cost = 07 and A.component is null;

my component table has the set of items i want to look in the cost table where the item might not be. I want to pull from that table what items on the component table does not exist. this is not exact code but resembels it

Answer 3

Make it a left join

Because this has a right join you are getting everything from table B and anything in A that matches (or null if none)

Left means give everything from A and the matching data from B (or null if no match)

Answer 4

do I have have to add anything more so i can get only the null values?

Answer 5

Where B.column is null

Answer 6

Where can I do code for sal program

Answer 7

Where can I do SQL code programming

Answer 8

Use left join?

Answer 9

SELECT name,year FROM production
WHERE name = 'marvel studios'
and year
between 2010 and 2019