CREATE VIEW c
SELECT a.a1, a.a2, b.a1, b.b1, b.b2
FROM a, b
WHERE a.a1 = b.a1
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.