Celt.Max

Well, I think [CODE] SELECT t1.id as id1, t1.name1, t2.name2, t3.name3 FROM test1 t1 LEFT OUTER JOIN test2 t2 ON t1.id = t2.id LEFT OUTER JOIN test3 t3 ON t1.id = t3.id [/CODE] might work correctly...

^ Jobless mindreader < Just ate a pot of kung-pao and is still hungry... all the day V Loves playing the tetris!

Well, there are more ways on my mind how to do this... [B]1) make it up with just one row[/B] - fill the Author collumn with names separated so it cant be easily machined with sql, but it should be no problem with other programming, eg.: [ICODE]Id Author 1 E.M.Remarque …

Hi, here you can find a code solving one part of your problem: [URL="http://www.dreamincode.net/code/snippet318.htm"]http://www.dreamincode.net/code/snippet318.htm[/URL] Just delete "Text1.Text = sText" and place "Text1.Text = sNextLine" instead of "sText = sText & sNextLine". And one line after use a Sleep(10000) function, declared when declaring variables as: [CODE] Private Declare Sub Sleep Lib …

I have a scary query on MSSQL 2005 here... Got a wiew that returns 2110 rows... and a table of cca 1 500 000 rows. Now, when I run this query [CODE] SELECT TS.col1, TS.col2, count(*) AS Number FROM view_scary VS LEFT OUTER JOIN table_scary TS ON VS.IdContact = TS.IdContact …

If you'd like to visit some site through the vb application (i was developing only in Visual Studio 6), it's all about adding a "Microsoft Internet Controls" into your component panel and then just lay it on your form window. This control needs an Internet Explorer browser installed on the …

Hi, it doesn't work because the variables distance and time are declared as integer. So if you put down in your inputbox for the distance e.g. the word "apple", it will automatically convert to value 0... and 0 is numeric. The solution for your problem is in declaring those two …

Hi there... "the 1st character" ~ Left(Range("X" & y), 1) "the 2nd character" ~ Mid(Range("X" & y), 2, 1) where X you can change for the letter of your column

These two lists looks both the same. I guess this web didn't formated them well, so I don't now, what do you want to do with them exactly, but if you just want to make the lists aligned into nice columns, then try: 1) Right click on listbox and choose …

I'm not sure if the solution is so easy as you write... VB(at least my 6 one) does not have the sum function... its necessary to write it at first. It could looks like this: [CODE] Public Function SUM(sNumber as String) As Integer dim iX as integer, iCount as integer …

Well... let the first table has a name of "tblOld" and the second one "tblNew". As you said - fill the tblNew with CarId. But the new table has to have also other columns, I mean Size, Name and Color. It's quite easy then: [CODE] UPDATE tblNew SET Size = …

Hi... if you want to get a special number on every start, try to add this line on first row of your fnc: [CODE] Randomize Timer [/CODE] If you'd like to get unique numbers, e.g. for some series numerical, you probably have to make an array, a loop and shoud …

Hi everybody, I have really damned trouble here... On MSSQL 2000 I have something about 140 log tables with three columns in each one. "ID" AS INT, "SomeTextCODE" AS NVARCHAR(20) and "SomeTime" AS DATETIME I made a view (v_SomeView_ALL) in which there are all these tables united. But some SomeTextCODEs …