Ima, ispadaju SQL upiti na sve strane
Kôd:
SELECT U.UserID AS UserID, U.UserName AS KorisnickoIme, W.WebMasterTypeID AS Tip, W.WebMasterAddressStreet AS Ulica, W.WebMasterAddressNumber AS Broj,
W.WebMasterAddressPostalNumber AS PostanskiBroj, W.WebMasterPlace AS Grad, W.WebMasterCountry AS Zemlja, W.WebMasterEMail AS EMail,
W.WebMasterPrimaryContactPhone AS Fiksni, W.WebMasterMobilePhone AS Mobilni, W.WebMasterFax AS Faks, W.WebMasterContactPersonFirstName AS Ime,
W.WebMasterContactPersonLastName AS Prezime, P.PersonRegistryCode AS JMBG, BE.BusinessEntityName AS Firma, BE.BusinessEntityRegistryCode AS MBR,
BE.BusinessEntityTaxAuthorityCode AS PIB
FROM `User` AS U
Inner Join WebMaster AS W ON U.UserID = W.UserID
Left Outer Join Person AS P ON P.WebMasterID = W.WebMasterID
Left Outer Join BusinessEntity AS BE ON BE.WebMasterID = W.WebMasterID
WHERE U.UserID =