i need help creating sql = member id, member type, company sorted by company within member type?
963347
Select member ID, member type, company \nfrom (insert table name here) \ngroup by member type, company \norder by member type, company
619166
Try using a datagrid. You can use SqlDataReader object and populate the datagrid.
687165
First create the table with the data, then go to the query tab and select the wizard query, it will walk you through the steps to creat one. \nOnce you have your query set up, you can sort and filter as you wish.
861304
Add LIMIT 10 to the end of your sql command\n\na few example could include\n\nSELECT  * FROM table LIMIT 0 , 10\n\nor if you want only unique values to show use \n\nSELECT DISTINCT  field FROM table LIMIT 0 , 10\n\nor unique from all\n\nSELECT DISTINCT  *  FROM table LIMIT 0 , 10\n\nPm/IM me on yahoo:  Supermrnice if you would like a very useful tip i use
568859
select name, count(rowid) from simple_table\ngroup by name\nhaving count(rowid) > 1\n\nhope it helps!
692712
The best way to do this is to create a query that concatinates the two fields (assuming that the title of the column and the data in each row is the same). To do this you need to created a new Primary Key on your output table which contains both the columns from the two different tables (this is known as a compound key).\n\nHope this helps.
162779
As a business librarian, I suggest you try Hoovers business database:\n\nhttp://premium.hoovers.com\n\nThis is the best place to build current, accurate, and comprehensive company and business lists.
896456
mySQL should be part of your solution.\n///
428028
An extended example:\n\nSELECT * FROM MYTABLE ORDER BY date,price
743722
Hello,\nThe inner query, which is\n\nSELECT [Employee Information].FirstName, [Employee Information].LastName, Courses.CourseTitle, CoursesCompleted.CourseID\nFROM Courses INNER JOIN ([Employee Information] INNER JOIN CoursesCompleted ON [Employee Information].StudentID=Courses... ON Courses.CourseID=CoursesComple...\nWHERE (((CoursesCompleted.CourseID)=... THE COURSE NUMBER])))\n\nreturns a set of first names, last names, course titles and course id numbers; however you are checking whether >only< the first name and the last name of a particular employee is in that set. If I'm not mistaken, both sides of the 'NOT IN' clause should contain the same information. In this example, one side (outer query) contains the name of the employee, and the other side (inner query) contains the name of the employee + course information. \nTry this: in the second query select only the first and last name of the employee (not the course info) but keep the joins in the FROM clause.\n\nIf I had designed the tables, I would assign a unique id to each employee, just as courses have their unique course ids. It would have eased this task a lot.\n\nI know I sound confusing, but hope it helps
774615
I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161\n\nHope that helps! Sounds like fun!
913812
Here are some that I think might be very useful to you:\n\n- http://www.analysisandsolutions.com/code/mybasic.htm\n- http://dev.mysql.com/doc/\n- http://www.w3schools.com/sql/\n- http://www.freewebmasterhelp.com/tutorials/phpmysql/1\n- http://www.devshed.com/c/b/MySQL/\n\nOf course you can find lots others but these are the best to start learning SQL.\n\nHope this helps.
1011647
My coldfusion is pretty rusty (php guy now) but the first question that comes to mind is, rather than use 2 seperate queries, why not use one?\n\nTry SELECT * .... etc\n\nWHERE order_ID = (SELECT MAX(order_ID) FROM Orders)\nORDER BY ... etc.\n\nThis is called a subquery or correlated subquery.  Most SQL databases support the idea.
437824
If you have the ability to enter a direct SQL statement into UltraDev when you are binding this data, your SQL statement would look something like this:\n\nSELECT a.*, b.* FROM troubleshootingtable a INNER JOIN servertable b ON a.servernamecolumn = b.servernamecolumn WHERE a.recordidcolumn= 'recordid'\n\nIn the statement above:\n\nReplace "troubleshootingtable" with the name of the troubleshooting table\n\nReplace "servertable" with the name of the table that holds your server info\n\nReplace "servernamecolumn" with the names of the columns that hold your server names. For example, if that's called server in the troubleshooting table, then a.servernamecolumn would be changed to a.server; if it's called servername in the servers table, you'd change b.servernamecolumn to b.servername\n\nReplace "recordidcolumn" with the name of the primary key column in your troubleshooting table.\n\nReplace "recordid" with the name of the variable you will be using to get the right record.\n\nIf this doesn't help, follow up and I will try to clarify.
808315
I havn't done it mysqlf but a good place to start is with the TI-83 SDK and the documentation. The headers and required includes usually have a lot of information on how they can be used and often have a brief tutorial/starter project to build off of.
1044851
One question: when you type "2" in the field t4f3, what do you want to lookup in table 2? Fields? Records? All fields? All records? I believe you're not designing the right way your database. Please be more specific.\n\nMakiavel
1059497
Select * from employee_master_table where employee_name like '%%entered_employee_name%%'\n\ncheers !!!!\n\nHello Mate,\n\nI program in PHP. below is a sample code form PHP, maybe this would be of some help to you.\n\n<?\n\n\n$user="ISAdmin";\n@$password="********";\n@$database="my_DB";\n@mysql_connect(localhost,$user,$password) or die ("could not connect to database");\n@mysql_select_db($database);\n\n$query = "select * from my_DB";\n\n$result = mysql_query($query);\n\n$num=mysql_numrows($result);\n\necho "<p>$num records found!!!!";\n\n$i=0;\nwhile ($i < $num) \n\n{\n\n$tmpid=mysql_result($result,$i,"dataid");\n/*($result,$i,"dataid")\n$tmpname=mysql_result($result,$i,"databname");\n/*($result,$i,"databname")\n\n$savetofile=  "<p><a href=&#92;"index.php?transtype=$transid&data=$tmpid&#92;"> $tmpid   $tmpname </a>";\n\necho $savetofile;\n\n$i++;\n\n}\n\n\n$delthis = $_GET['data'];\n\nif($delthis<>"")\n{\n\n\n$query = "select from my_DB where dataid=&#92;"$delthis&#92;"";\n\n$tmpid=mysql_result($result,$i,"dataid");\n\n$tmpname=mysql_result($result,$i,"databname");\n\n\n<form>\n<input type= text" name="text1" value="<?echo $tmpid?>"?\n<input type= text" name="text2" value="<?echo $tmpname?>"?\n</form>\n\n@mysql_close();\n}\n\n?>