Pogledajte određenu poruku
Staro 12. 04. 2010.   #42
mileusna
Super Moderator
Knowledge base
 
Datum učlanjenja: 20.03.2006
Lokacija: Kragujevac
Poruke: 1.878
Hvala: 291
1.345 "Hvala" u 355 poruka
mileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobarmileusna je jednostavno dobar
Default

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 =
mileusna je offline   Odgovorite uz citat
2 članova zahvaljuje mileusna za poruku: