Umm, it is free for public use, not commercial use. Commercial use it costs something like 400-500 dollars per license (which is cheap). Rather than MS SQL which charges per processor at almost...

This is what I have so far, all for asp.net:
repeater1: "SELECT UserName, LastLogin, DateCreated, Views, Logged,
(SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=?) As TotalAlbums,
(SELECT...

hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one.

What I need is to make the following queries into one:
SELECT Username, LastLogin,...

Nevermind, figured it out. Thanks anyway:
"SELECT Albums.AlbumLabel, Albums.AlbumID, Albums.DateCreated, Albums.AlbumDate, Albums.AlbumLocation, Albums.AlbumEvent, SUM(Photos.Views) FROM Albums,...

if anyone can please help...



This is what I have but, obviously does not work:
"SELECT Albums.AlbumLabel, Albums.AlbumID, Albums.DateCreated, Albums.AlbumDate, Albums.AlbumLocation,...

oh no sorry it doesn't work. This is how it's set up:

2 tables, one deals with albums and is relational to the photos table only by AlbumID.
In the photos table, each photo has a "View" that is...

I am pulling a simple query but basing it off of a group of sums. What I want to do is pull all the information from "albums" where albumID equals "photos" albumID. Then Grouping by Photos.albumID, I...

For all:
all the "%" do is tell MySQL it is a wild card. So "am" with "%am%" pulls up anything with any number of letters before the combo "am" and any number of letters after:

name - n am e...

There are no max tables with MySQL, but that depends on your system. But there are just about 3400 max columns in a single table.