Search:

Are you missing a closing paren for the role?

For the creation of your view, couldn't you use this select?

select max(id), owner, document from doctable group by owner, document;

Then I think you would have the id of the most current...

I don't know the DBMS syntax, but I think this
"foreign key(id33) references table1,foreign key(id33) references table2)"
should be more like this
Foreign Key (id1x) references table1(id1)...

Looking at the mysql 5.0 reference manual, under other functions, there is a function called row_count() - returns the number of rows updated, inserted, or deleted by the preceding statement and it...

Is there a "IN" in MSSQL? For example:

Select ..... Where attribute_values IN #form.searchsize#

Are you pointing to different copies of the database (i.e. development version of the database vs. live production version of the database)?

I think that you need a GROUP BY and that it will need to include all the columns you selected.

Joseph - If someone like a DataBase Administrator is taking care of the database, then you probably don't need to worry about the backup, recovery and some of the database functions. You should...

Hi. I know you have this resolved, but based on what you said, I think that you want an automatic update whenever the row gets updated. You may want to do some research into your MySQL's procedures...

I think that you need to use the "Group By" clause and alias names. I don't know if the following sql is right or not because I don't have time to setup tables to test this, but I'm thinking along...

Table 1 primary key of 'iop' has been inserted.

Table 2 primary key of 'rey' has been inserted.

Table 3 primary key of 'you did not specify with 'ioprey' as the foreign key should work. Is...

Do you have indexes defined? Below is from MySQL 5.0 Reference:


"14.2.6.4. FOREIGN KEY Constraints
InnoDB also supports foreign key constraints. The syntax for a foreign key constraint...

Insert or update triggers may be helpful. For instance, if deptname is the column that you want in uppercase then for an insert:

create trigger dept_name_caps before insert on depttable for each...

Agree, union will work.

select a.dept_id, a.acct, a.spend, a.budget from budget a, dept where dept.dept_id=a.dept_id and dept.acct=a.acct
union select dept_id, acct, 0, 0 from dept where not...