Answers for "query doesn't work if foreign key is null"

foreign key not null constraint

create table orders
(
        ord_no numeric (5) ,

        purch_amt decimal(8,2),

        ord_date date,

        customer_id numeric (5) ,
        
        salesman_id numeric(5) 
        
        foreign key(salesman_id)

        references salesman (salesman_id)
)
go

Posted by: Guest on September-17-2021

Code answers related to "query doesn't work if foreign key is null"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "query doesn't work if foreign key is null"

Code answers related to "query doesn't work if foreign key is null"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "query doesn't work if foreign key is null"

Code answers related to "query doesn't work if foreign key is null"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us