Need to pull records from 2 views

[citizenzen]

Need to distinct records from 2 views

I have the following views:

1) view_locateapprovMedia
2) view_shwApprovedDet

view_shwApprovedDet shows all approved requests.

view_locateapprovMedia displays all barcodes that exists in view_shwApprovedDet.

The problem is that I need to display
the following result:

Request# (detailsID)
User
Barcode
ItemID
Library
Shelf#
Shelf

How can I get this data correctly? I tried a join, a union, everything, but nothhing seems to work.

view_locateapprovMedia comes from view_shwApprovedDet and view_barcodes.

View_showApprovedDet is a UNION statement.

Here's the sql query for the view_locateapprovMedia VIEW:

SELECT ItemID, Barcode, ShowID AS ShowNum, Show, MusicID AS MusicNum, ARTIST, TITLE AS Video, ElementNumber AS Element, ElementShow, Library, 
[Shelf Number], [Shelf Name]
FROM         dbo.view_showBarcodes
WHERE     EXISTS
(SELECT     * FROM          
view_shwApprovedDet
WHERE      view_shwApprovedDet.ShowID = view_showBarcodes.[fk program ID] OR                      view_shwApprovedDet.MusicID = view_showBarcodes.[fk video ID] OR                                                   view_shwApprovedDet.ElementNumber = view_showBarcodes.[ElementNumber])

CODE FOR View_showApprovedDet

SELECT     view_mediaDubsDetails.Record AS DetailsID, view_mediaDubsDetails.ElementNumber, view_mediaDubsDetails.fk_showID AS ShowID, 
                      view_mediaDubsDetails.Show, view_mediaDubsDetails.fk_musicID AS MusicID, view_mediaDubsDetails.Video, 
                      view_mediaDubsDetails.DateNeeded AS NeedsBy, view_mediaDubsDetails.Length AS Length, view_mediaDubsDetails.Copies AS Add1, 
                      view_mediaDubsDetails.UserID
FROM         view_mediaDubsDetails INNER JOIN
                      view_mediaDubRequests ON view_mediaDubRequests.Record = view_mediaDubsDetails.fk_mediaDubReq
UNION
SELECT     view_mediaCheckoutDetails.mediaCheckoutID AS DetailsID, view_mediaCheckoutDetails.ElementNumber, 
                      view_mediaCheckoutDetails.showID AS ShowID, view_mediaCheckoutDetails.Show, view_mediaCheckoutDetails.VideoNum AS MusicID, 
                      view_mediaCheckoutDetails.Video, view_mediaCheckoutReqs.dateRequested AS NeedsBy, view_mediaCheckoutDetails.Length AS Length, 
                      ISNULL(view_mediaCheckoutDetails.cpyCount, 0) AS Add1, view_mediaCheckoutDetails.UserID
FROM         view_mediaCheckoutDetails INNER JOIN
                      view_mediaCheckoutReqs ON view_mediaCheckoutDetails.fk_mediaCheckoutID = view_mediaCheckoutReqs.CheckoutRequest