rutgermons
asked on
specify yorn if field is populated in other relationsal table
folks
i have two tables
workorder and asset
in my asset table I have data like so
asset contract
car1 waranty1
car1 waranty2
car2 null
car3 repair
in my workorder table i have three fields
workid asset description
1 car1 broken
2 car2 inop
how can i add a field into my query to state in YORN form if the contract field is present
to that specific asset in my asset table like so
workid asset description contracts exist?
1 car1 broken Y
2 car2 inop N
All help will do
r
i have two tables
workorder and asset
in my asset table I have data like so
asset contract
car1 waranty1
car1 waranty2
car2 null
car3 repair
in my workorder table i have three fields
workid asset description
1 car1 broken
2 car2 inop
how can i add a field into my query to state in YORN form if the contract field is present
to that specific asset in my asset table like so
workid asset description contracts exist?
1 car1 broken Y
2 car2 inop N
All help will do
r
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
from asset a
left join workorder w
on w.asset = a.asset