Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Which join is the most fast
Hello sql users, Can someone of you tell us wich kind of join the most fasted is? inner or left/right outer join? Nice regards, Ton. -
selection with 2 joins to the same table
Dear sqlserver 2000 users, We don't know or this is the right forum but maybe there is someone who can help. We are busy to create a simple select statement. In this select statement there are two joins to one tabel. TblReaders Name1_id name2_id 1 2 3 4...- tonvaneck
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
select with two joins to one table
Dear sql users, We are busy to create a simple select statement. In this select statement there are two joins to one tabel. TblReaders Name1_id name2_id 1 2 3 4 TblNames Id Names 1 John 2 Mary 3 Edward 4 NN The query must create next result: Name1 Name2 John Mary Edward NN... -
still exccution error 1045
Dear Mysql users, Asking this error for a few weeks, we do have stille the same error. We are using the program "MySQL front", if fill in the servername/username/password and we want to chose a database in our Mysql database we get the error shown on our site... -
Connection to apachy / mysql
Dear PHP users, We want to make, with a PHP file, a connection to apachy / mysql to show the contents of a table. Also we want to change the content. Can someone give us a example source how to do that? The apachy server is a local one. Nice regards, Ton van Eck. -
Dear Mysql users, At my work it
Dear Mysql users, At my work it not possible to get a connection with my apachy and mysql. If we try the next error occured: Error 1045 (access denied for user: ‘admin@localhost’ (using pasword: YES)) The internet is working with a LAN If I connect apachy / mysql on a local machine there is... -
How to create a table
Hello MySql users, Using the tool isql 1.0.3 we are trying to create a table with the next sql statement: use test create table NewTb (MyFld char(20) not null); an error code 1064 is generated (a syntax error) Can someone tell me what we do wrong? Nice regards, Ton. -
How to configure MySql
Dear MySql users, For configuring MySql we found the “interactive sql for mysql version 1.0.3” but after 15 days it will stop with working. Is there any tool, for free, to configure a MySql database or a password for the isql 1.0.3 Nice regards, Ton.
