Hi,I assume you want to output the Name from table2, if it's present, in which case:SELECT a.id, isnull(b.name, 'NA'), a.nameFROM table1 aLEFT JOIN table2 b ON a.no = b.idwill do it for you (I've also output the id and name from table1).EDIT:Apologies, I didn't see the MySQL tag until I posted. You will need to use the coalesce function instead if isnull, like so:

Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

SQL Mach two table

Anonymous User 2884 09 Jul 2013

Hi Expert!

I've 2 table.

Table1

Has count about 2700 rows

Colums: ID, NO, NAME

Table2:

Has count about 300 rows

Colums: ID, NAME

where:

Table1.NO = Table2.ID

I want to list Table1(2700 rows) but if Table1 doesn't contain some of Table2's rows I want to write "NA"

How can i do that with SQL.

Thanks in advance.

Ask by Anonymous User

Updated 09 Jul 2013

1 Answers

AVADHESH PATEL 09 Jul 2013

Hi,

I assume you want to output the Name from table2, if it's present, in which case:

SELECT

a.id,

isnull(b.name, 'NA'),

a.name

FROM

table1 a

LEFT JOIN

table2 b

a.no = b.id

will do it for you (I've also output the id and name from table1).

EDIT:

Apologies, I didn't see the MySQL tag until I posted. You will need to use the coalesce function instead if isnull, like so:

SELECT 
    a.id,
    coalesce(b.name, 'NA'),
    a.name
FROM
    table1 a
LEFT JOIN
    table2 b
    ON
    a.no = b.id

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

SQL Mach two table

Can you answer this question?

1 Answers