Table Join - Printable Version

The following warnings occurred:

Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)

File	Line	Function
/global.php(961) : eval()'d code	26	errorHandler->error
/global.php	961	eval
/printthread.php	16	require_once

Table Join - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: Table Join (/showthread.php?tid=315)

Table Join - JeffJ - 10-19-2016

I'd like to create a MySQL view that joins the UserSpice user table with my own user table using a SQL JOIN. This seems possible if I install UserSpice into my existing database. Is it possible to install UserSpice into an existing MySQL database (i.e., a database that's already populated with several other tables)?

Thanks.

Table Join - mudmin - 10-19-2016

Absolutely. I install userspice in the same db as wordpress and joomla all the time. The only issue is that userspice will not natively support db_prefixes for its own tables until 5.0. There are ways around it, other than that, it works great.